home *** CD-ROM | disk | FTP | other *** search
Wrap
HBAM2001MAY84 JJLcheckDataAddV1.0E:* 2780300 Pro 1.0F! Pro 1.0I Main Dictionary User Dictionary 13-11-1995 COMMENT A8278 & If(Length(E1) = 3 ,0 & Left(E1,2),Left(E1,3)) & 0 AreaB @@#1B TextToNum(Area) & Left(Abo ,1) @@#2B CompleteB YesfD YesfD Helvetica If (@#2 0 ,"",278 & If(Length(E1) = 3 ,0 & Left(E1,2),Left(E1,3)) & 0 )))) If (@#2 0 ,"Ent NieuwB YesfD YesfD n the new / nieuw field bel If a new series of subscriber numbers is introduced, (E.g. 030-5xx xx xx) you can add the whole series to the the file JJLcheckData by entering the area code and one subscriber number below: If the data are acB ceptable, open the file JJLcheckData, import (from the File Menu, select match fields) and all new numbers of this form will be accepted. E Area Code Subsciber number Comment r hieronder het netnummer en een nieuw abonnee nr in te tikken. De benodigde gegevens worden dan uitgerekend en kunB`nen vervolgens in de file JJLcheckData geimporteerd (Met Importeer uit het Archief menu) worden. Kengetal Abonnee nummer Commentaar Pro 1.0F! Pro 2.0 - 2.1I Main Dictionary User Dictionary JJLcheckData CommentB If(Length(TextToNum(Area)) + Length(TextToNum(Abo)) 9 , "Length of valid new numbers must be ten digits", If(TextToNum(Middle(@#3,4 ,3)) TextToNum(Ar@@#4B JJLcheckData JJLcheckDataK If(Length(TextToNum(Area)) + Length(TextToNum(Abo)) 9 ,"", If (TextToNum (Middle (@#3,4 ,3)) TextToNum (Area) and TextToNum (Middle (@#4,4 ,3)) Text "", If (@@#2 0 ,"",@@#1))) JJLonlyB Users YesfD Helvetica Chicago Monaco Geneva Fields Import Jjlcheckdata Matching Valid Fields Import Jjlcheckdata Matching Valid worden dan uitgerekend en kunB`nen vervolgens in de file JJLcheckData geimporteerd (Met Importeer uit het Archief menu) worden. YesfD YesfD y already exists, do not import!", "OK, valid data. To add, open JJLcheckData and import the two matching fields")))) '.Length of valid new numbers must be ten digits& '+Area code does not exist yet, are you sure? JJLcheckData not exist yet, are you sure?& '#Abo cannot begin with 0, 1, 8, or 9& '#Entry alrBLeady exists, do not import'-OK, valid data, go to JJLcheckData and import @@#4B JJLcheckData If(Length(TextToNum(Area)) + Length(TextToNum(Abo)) 9 ,"", If (TextToNum (Middle (@#3,3 ,3)) TextToNum (Area) and TextToNum (Middle (@#4,3 ,3)) TextB ToNum (Area),278 & If(Length(E1) = 3 ,0 & Left(E1,2),Left(E1,3)) & 0 , If (Left (Abo,1) 1 or Left (Abo,1) 8 ,"", AreaB TextToNum(Area) & Left(Abo ,1) JJLcheckData AreaB @@#1B TextToNum(Area) & Left(Abo ,1) @@#2B '2Subscriber numbers cannot begin with 0, 1, 8, or 9& '$Entry already exists, do not import!'LOK, valid data. To add, open JJLcheckData and import the two matching fields '#Abo cannot begin with 0, 1, 8, or 9& '#Entry already exists, do not import'EOK, valid data, go to JJLcheckData and import the two matching fields K, valid data, go to JJLcheckData and import the two matching fields ToNum (Area),@#1, If(Left(Abo,1) 1 or Left(Abo,1) 8 ,"", C If (@#2 0 ,"",@#1)))) JLcheD.ckData and import the two matching fields")))) 2780300 3780100 3780100 2780300 3780100 3780100 Pro 1.0F! Pro 1.0I Main Dictionary User Dictionary Fields Import Jjlcheckdata Matching Valid Pro 1.0F! Pro 1.0I Main Dictionary User Dictionary 2780300 2780300C 305HLOK, valid data. To add, open JJLcheckData and import the two matching fields hing fieldsI 2780300 User Dictionary ea) and TextToNum(Middle(@#4,4 ,3)) TextToNum (Area), "Area code does not exist yet, are you sure?", If(TextToNum(Left (Abo,1)) or TextToNum(Left (Abo,1)) 8 , "Subscriber numbers cannot begin with 0, 1, 8, or 9", If (@#2 0 ,"Entr ckData and import")))) 2780300C 030D 555 55 55E 2780300HLOK, valid data. To add, open JJLcheckData and import the two matching fieldsI 2780300